Skip to main content

Week 04

Feb 21

  • how does Haurum et al. 2022 paper affect my thesis

FME to python

  • create a notebook in acrgis pro python having a function on how to create the watershed and push the notebook to github

Feb 22

  • List of WRc and PACP and combine

  • If the image has label BSV and then add B in that image. Add the higher hierarchy label to the image

  • There are 4026 unique job numbers inside CCTV_Details. The job numbers can either contain the video extension such as mpg or mp4 (e.g. SANMN00692_49.MPG) as part of its name or only have the filename (e.g. 001-3648)

  • 736 job numbers from CCTV_Details are found to follow PACP standards.

  • 406 out of 736 job numbers have matching file names (without considering the file extension) with videos on the Gdrive.

  • 1472 out of 3572 videos inside the "January 2023 DNV upload" folder on the Gdrive have matching file names (without considering the file extension) with job numbers in the CCTV_Details table.

  • There are 2554 job numbers in the CCTV_Details table without their corresponding videos on the Gdrive.

  • There are 2100 videos on the Gdrive without their corresponding condition data.

  • The inspector did not move back to make sure the tap is visible in the frame when logging tap code. Therefore, we might have to decrease the distance value reported in condition data by 0.1 or 0.2 to get the frame where tap is visible.

  • SANMN02925_601.mp4 should at list SRI (surface roughness increased) or SRV( reinforcement visible)

Feb 23

  • create a diagram

  • add issue with new data slide. The inspector did not move back to make sure the tap is visible in the frame when logging tap code. Therefore, we might have to decrease the distance value reported in condition data by 0.1 or 0.2 to get the frame where tap is visible

  • WRc vs PACP

    • code is identical
    • code is different
  • WRc label replace by PACP

  • Adding infomration from Joint column to PACP. For an example if B is at Joint, add label as BJ.

  • Defect prediction (pure feature engineering)

    • What install
    • age vs when defect happen (age at which defect is noted)
    • pipe material
    • pipe shape
    • soil type
    • type flow
  • Add the evolution of defect standard in Thesis

Feb 24

  • SANMN05099_50.csv from the new OCR Processor with Azure matches with the one generated from the old OCR Processor with Azure notebook